﻿<!DOCTYPE html>
<html>
	<head>
		<title>Align data in cells</title>
		<meta charset="utf-8" />
		<meta name="description" content="Everything that pertains to the data alignment in cells" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
			<h1>Align data in cells</h1>
			<p>You can align your data horizontally and vertically or even rotate data within a cell. To do that, select a cell, a range of cells with the mouse or the whole worksheet by pressing the <b>Ctrl+A</b> key combination. You can also select multiple non-adjacent cells or cell ranges holding down the <b>Ctrl</b> key while selecting cells/ranges with the mouse. Then perform one of the following operations using the icons situated at the <b>Home</b> tab of the top toolbar.</p>
			<ul>
				<li>Apply one of the horizontal alignment of the data within a cell,
					<ul>
						<li>click the <b>Align left</b> <div class = "icon icon-alignleft"></div> icon to align your data by the left side of the cell (the right side remains unaligned);</li>
						<li>click the <b>Align center</b> <div class = "icon icon-aligncenter"></div> icon to align your data by the center of the cell (the right and the left sides remains unaligned);</li>
						<li>click the <b>Align right</b> <div class = "icon icon-alignright"></div> icon to align your data by the right side of the cell (the left side remains unaligned);</li>
						<li>click the <b>Justified</b> <div class = "icon icon-justify"></div> icon to align your data by both the left and the right sides of the cell (additional spacing is added where necessary to keep the alignment).</li>
					</ul>
				</li>
				<li>Change the vertical alignment of the data within a cell,
					<ul>
						<li>click the <b>Align top</b> <div class = "icon icon-aligntop"></div> icon to align your data to the top of the cell;</li>
						<li>click the <b>Align middle</b> <div class = "icon icon-alignmiddle"></div> icon to align your data to the middle of the cell;</li>
						<li>click the <b>Align bottom</b> <div class = "icon icon-alignbottom"></div> icon to align your data to the bottom of the cell.</li>
					</ul>
				</li>
				<li>Change the angle of the data within a cell, clicking the <b>Orientation</b> <div class = "icon icon-orientation"></div> icon and choosing one of the options:
					<ul>
						<li>use the <b>Horizontal Text</b> <div class = "icon icon-horizontaltext"></div> option to place the text horizontally (default option),</li>
						<li>use the <b>Angle Counterclockwise</b> <div class = "icon icon-anglecounterclockwise"></div> option to place the text from the bottom left corner to the top right corner of a cell,</li>
						<li>use the <b>Angle Clockwise</b> <div class = "icon icon-angleclockwise"></div> option to place the text from the top left corner to the bottom right corner of a cell,</li>
						<li>use the <b>Rotate Text Up</b> <div class = "icon icon-rotateup"></div> option to place the text from bottom to top of a cell,</li>
						<li>use the <b>Rotate Text Down</b> <div class = "icon icon-rotatedown"></div> option to place the text from top to bottom of a cell.
                        <p>To rotate the text by an exactly specified angle, click the <b>Cell settings</b> <div class = "icon icon-cellsettings_rightpanel"></div> icon at the right sidebar and use the <b>Orientation</b>. Enter the necessary value measured in degrees into the <b>Angle</b> field or adjust it using the arrows on the right.</p>
                        </li>
					</ul>
				</li>
				<li>Fit your data to the column width clicking the <b>Wrap text</b> <div class = "icon icon-wraptext"></div> icon.
					<p class="note"><b>Note</b>: if you change the column width, data wrapping adjusts automatically.
				</li>
			</ul>
		</div>
	</body>
</html>